EMT Practice Test

1. Question Content...

---

Question1: CRM Analytics consultant receives a new project from a client that wants to implement CRM Analytics. They do not currently have CRM Analytics but want guidance on how to ensure their users have the correct access.
They have 1,000 users with a small team of three people who will build both datasets and dashboards. An additional 15 people should be able to only create dashboards. The remaining users should only be able to view dashboards.
Which recommendation should the consultant give the client?
Which recommendation should the consultant give the client?

Question2: At Universal Containers, a dashboard is built to track sales metrics. The Opportunity amount field has conditional formatting added - it turns green for closed won and red for closed lost.
How should a CRM Analytics consultant enhance the dashboard design to become more accessible to users with color vision challenges?

Question3: Universal Containers (UC) recently activated data sync in the CRM Analytics data manager. After running the sync, UC notices that the aggregate sum of a field within the company's dataset is different than what they manually calculated by summing the same data in the Salesforce object.
What is causing the issue with the newly synced data?

Question4: Universal Containers plans to upload target data from an external tool to CRM Analytics so it can calculate the sales team target attainments.
The target data changes every month, so the datasets need to be updated on a monthly basis. The target data is a CSV file that contains the Salesforce ID of the sales rep, the target amount, and the month of the target. For each sales rep, the file contains a target for every month of the current year as well as all previous years.
Based on this information, which operation should a consultant use with the Analytics External Data API to upload the file?

Question5: A consultant is preparing a dataset to predict customer lifetime value and is collecting data from a questionnaire that asks for demographic information. A very small number of respondents fill in the Income box, but the consultant thinks that it is an informative column even though it only represents 1% of respondents.
What should the consultant do?

Question6: The below image shows a numeric outcome being deployed (Regression).

Which metric is used to calculate the performance of the model in production, specifically in the Model Manager?
The below image shows a numeric outcome being deployed (Regression).
Which metric is used to calculate the performance of the model in production, specifically in the Model Manager?

Question7: Universal Containers (UC) builds three Einstein Discovery models in Salesforce to predict and maximize its revenue per customer. The models are for every region UC has a business: EMEA, AMER, and APAC.
How should a consultant help UC deploy the three Einstein models to Salesforce?

Question8: CRM Analytics team is asked to build a Service Analytics dashboard for the service agents.
What are the main "Deep Design Thinking" principles the team should keep in mind during the discovery sessions?

Question9: A project team member uploads a CSV file to CRM Analytics, and they notice a few records failed during the upload. The manager wants to view the error log generated so this can be fixed and uploaded again. The manager has the CRM Analytics administrator permission but is unable to download the error log details.
Why is the manager unable to download the log details?

Question10: A consultant sets up a Sales Analytics templated app that is very useful for sales operations at Universal Containers (UC). UC wants to make sure all of the data assets associated with the app, including:
recipes, dataflows, connectors, Einstein Discovery models, and prediction definitions are refreshedeveryday at
6:00 AM EST.
How should the consultant proceed?

Question11: CRM Analytics users at Cloud Kicks are granted access to an app with specific dashboards. When trying to download a specific widget, they are unable to do so.

Question12: Universal Containers builds a new sales dashboard and wants to make sure account managers can access the dashboard while traveling.
What should the consultant consider doing in this process?

Question13: Universal Containers has a dashboard for sales managers that want to visualize their win rate.
Which chart type should the consultant use to keep track of targets?

Question14: Universal Containers uses CRM Analytics to build dashboards for different departments: Sales, Service, and Marketing. Users in the samedepartment have the same role and need to have access to the same dashboards.
Dashboards for different departments use some common datasets with the same row-level security.
How should a CRM Analytics consultant address this need?

Question15: A CRM Analytics consultant is performing column profiling on dimension column in a recipe. Newly-added rows are not being considered in the Results tab of the profile even though a sync was run for that specific object.
What is causing the issue?

Question16: A consultant wants to understand what the important predictors are in a model.
Where is this information found?

Question17: A versioning feature allows CRM Analytics users to be added as Publishers and make changes separately while a 'Live' version is still being used by other users. Once the changes are complete, the user can then set their updated version as the Live version.
Which CRM Analytics item is this leveraged for?

Question18: Universal Containers (UC) uses a Microsoft Azure SQL Data Warehouse to gather information about sales reps' objectives. UC wants to use CRM Analytics to gain insights from this data and automatically load it into a CRM Analytics dataset daily. The data also needs to be transformed and merged with data from the company's org.
Which CRM Analytics user interface features should be used to complete these requirements?

Question19: Universal Containers (UC) is using CRM Analytics to create two datasets.
* Dataset A: Contains a list of activities with an "activityID" dimension and a "userID" dimension
* Dataset B: Contains a list of users with a "userID" dimension
UC wants to delete all activities from Dataset A related to users in Dataset B.
How should the CRM Analytics consultant help UC achieve this?

Question20: A CRM Analytics consultant is asked to help a company report on its sales activity. The company wants to train some users to create dashboards. The company also wants one other specific team to be able to use the dashboards.
What should the consultant do to address these requirements?

Question21: Cloud Kicks uses CRM Analytics for its sales reporting. A new manager needs access to CRM Analytics to see specific dashboards.
How should the system administrator give access to the Analytics
Studio app in the App Launcher?

Question22: In a dataset, there are multiple boolean fields. When displayed on any dashboard, the boolean fields should all be displayed in the same way: a value of true should result in the display of the word "Yes" in green; a value of false should result in the display of the word "No" in red.
How should the consultant accomplish this?

Question23: Universal Containers' sales team is looking to build a dashboard that shows the total revenue from their top
10 accounts (based on revenue) and make it dynamic with the filters of the dashboard.
Which action is required to accomplish this?

Question24: A consultant runs the sharing inheritance coverage assessment for the Opportunity object and finds that some records exceed 400 sharing descriptors.
What should the consultant do?

Question25: Universal Containers wants to create two dashboards and has two user groups. The 'Regional Performance' dashboard should be accessible to sales reps and managers/executives to keep track of how sales reps are performing in each region. Sales reps must only be able to see data pertaining to their respective region. The 'National Performance' dashboard is using the same data as the other dashboard but should only be accessible to managers/executives to compare data across all regions.
In addition to row-level security to view only regional data, how should a consultant ensure that sales reps are unable to view the 'National Performance' dashboard?

Question26: Cloud Kicks' Salesforce org has multiple currencies enabled. This company's business intelligence team uses CRM Analytics to build a dataflow/recipe that creates a dataset, "OpportunityDataSet", which is populated with data extracted from Opportunity. One of the extracted fields is the standard field, Amount.
Which currency will the Amount values be shown in "OpportunityDataSet"?

Question27: The CRM Analytics consultant at Cloud Kicks is asked to a dashboard displaying Opportunities data on the account's record page. The dashboard should display only opportunity data related to the current account viewed.
How should the consultant accomplish this?

Question28: A CRM Analytics consultant is asked to make changes to the current sales dashboard at Cloud Kicks. The dashboard is crucial to track the daily sales performance of the company and needs to be available for other users while the consultant works on the changes.
How should the consultant proceed to update the dashboard?

Question29: Universal Containers intends to use a custom Salesforce big object in its org and visualize the data using CRM Analytics. As the number of rows to be synced is quite large, the CRM Analytics consultant is looking to set up an incremental sync with additional filters added as part of the data sync to improve performance.
What should the consultant keep in mind while implementing this?

Question30: An CRM Analytics consultant is working with Ursa Major Solar to build a dashboard to understand customer renewals. Each subscription is captured as a Closed Won Opportunity within Salesforce and a single Account should only have one active subscription. The consultant notices the Opportunity record does NOT specify whether it is a renewal or a net new subscription.
Which data transformation should the consultant use to determine if a subscription is new or a renewal?

Question31: A consultant is tasked with creating a dataset and a dashboard for a sales team. During the requirements gathering, it was highlighted that security of the data is important.
It was noted that the Opportunity object has organization-wide defaults set to Private with access via the role hierarchy. Sales wants to keep this security in place for the dashboard. Looking at the Opportunity data, the consultant sees that the VP of sales can have access to up to 20,000 records and is unsure if sharing inheritance can be used.
Which approach ensures data security for the new Opportunity dataset?

Question32: Universal Containers' CRM Analytics team is building a dashboard with two widgets.
1. List widget associated to the query "Type_2" and grouped by the dimension "Type" (multi-selection)
2. Donut chart widget associated to the query "Step_pie_3" and grouped by the dimension "Type" The team wants to use bindings/interactions so any selection in the List widget will filter the Donut chart. The queries use different datasets, and users should be able to choose more than one Type (multi-selection).
What is the right syntax for the binding/interaction?

Question33: Universal Containers has a dashboard for sales managers. They need the ability to visualize the number of Closed Won opportunities by month, quarter, or year, and then display the result in a single chart. A CRM Analytics consultant creates a custom query to display three values:
ClosedDate_month, ClosedDate_ quarter, and ClosedDate_year.
What should the consultant do next?

Question34: AW Computing will start using Tableau Online to report on some of its Salesforce data to users who do NOT have an SFDC license.
What is the first step the CRM Analytics consultant should take?

Question35: The CRM Analytics consultant at Universal Containers has set data syncs and recipe runs back to back.
However, they notice that the data syncs and recipe run jobs fail repeatedly. Upon investigation, they realize the data syncs and recipes are tightly coupled which leads to too many runs being queued and eventually being canceled.
How should the consultant resolve this issue?

Question36: The sales team at Cloud Kicks is requesting that datasets for their dashboards be refreshed every hour. The CRM Analytics consultant investigates if this is possible and finds that the dashboards use five datasets created from two recipes. The first recipe takes 43 minutes to run and the second recipe takes 25 minutes to run.
Which consideration should the consultant keep in mind?

Question37: A system administrator and a CRM Analytics consultant are working together on deploying arecipe/dataflow and a dataset to another org. Prior to this deployment, a package was deployed with all the custom fields used in the dataflow and dataset.
While running the recipe/dataflow in the target environment, the consultant encounters multiple errors related to these custom fields.
How should this be resolved?

Question38: In Data Alerts, a field named Region is 96.5% North America. The consultant believes that this is an important field since the majority of sales is in the North American market.
What is the appropriate action?

Question39: A dashboard designer at Cloud Kicks creates a dashboard in CRM Analytics. The designer notices fields display on the dashboard with their APIlabels, such as "AccountId.Industry", and wants to change this behavior.
The designer also notices that the fields and their order appear to randomly change when a values table is created.
What should the CRM Analytics consultant explain to help the designer?

Question40: A new picklist value was added for the Category field on the Account object. This field is already added as part of the Account object data sync and the respective recipe that uses this field.
The CRM Analytics team reports that when they start the recipe it runs successfully with no errors or warnings, but they are unable to See this new values on their existing dashboards.
What is the oridi4 of this issue?

Question41: A CRM Analytics consultant has been asked to add a custom object to existing recipe. When trying to locate the object, the consultant can see only Direct Data and NOT the SFDC Local data sync.
How should the consultant resolve this?

Question42: Which recommended technique should a CRM Analytics consultant
use to access CRM Analytics data from a remote app or website?

Question43: Universal Containers has a dashboard for sales managers. They need to visualize the percentage of their opportunities in the pipeline in a Gauge chart. They want to customize the chart to keep track if they are below or beyond the target.

Which widget parameters should a consultant use?

Question44: Universal Containers' CRM Analytics team is building a dashboard with two widgets, and the queries use different datasets.
1. List widget associated to the query "Type_2" and grouped by the dimension "Type" (multi-selection)
2. Donut chart widget associated to the query "Query_pie_3" and grouped by the dimension "Type" The team wants any selection in the List widget to filter the Donut chart and vice versa. Users should be able to choose more than one Type (multi-selection).
What is the recommended way to accomplish the required filtering?

Question45: A client has two datasets that are used across seven different dashboards. Three of these dashboards are used by marketing and four are used by sales. The client requires that only marketing can access the marketing dashboards and only sales can access the sales dashboards.
Which solution should a consultant recommend?

Question46: A consultant is building a CRM Analytics dashboard for Universal
Containers. The consultant has enabled data sync to increase the
speed of datasets refreshing.
How often will the data on the dashboard be refreshed?

Question47: A manager at Cloud Kicks wants to separate and analyze accounts based on numeric information of its opportunity records. The data includes things like amount, quantity of products, contacts, and quotes.
How should the CRM Analytics consultant accomplish this?

Question48: Cloud Kicks has a dashboard that displays accounts and opportunities data in a table that contains actions to open the records in Salesforce. Since the company has allowed several accounts to be created with the same names, when users try to perform actions, they are prompted with only a record ID to select, leaving the users confused and unable to act.
How should the CRM Analytics consultant solve this problem?

Question49: CRM Analytics uses permissions of the Integration User to extract data from Salesforce objects and fields when a dataflow/recipe job runs.
Why should a consultant be cautious while syncing objects and fields containing sensitive data?

Question50: A CRM Analytics consultant wants to move a dataflow to a recipe in order to use aggregation nodes. To do so, they use the Dataflow to Recipe convertor and the recipe runs successfully.
However, they are unable to see the aggregated data in the dataset.
What is causing the issue?

Question51:
Which timeseries statement will fix the query?